package com.group3.hospital.mapper;/*
 *@author 时崎
 * 2021/12/30
 */

import com.group3.hospital.bean.Admin;
import com.group3.hospital.bean.User;
import org.apache.ibatis.annotations.Select;
import org.springframework.ui.Model;

import java.util.List;

public interface AdminMapper {

    @Select("select admin_tel,admin_name,admin_password from admin where admin_tel=#{adminTel} and admin_name=#{adminName} and admin_password=#{adminPassword}")
    Admin queryAdmin(Long adminTel,String adminName,String adminPassword) throws Exception;

    @Select("select username,userTel,userGender,userAge from user")
    List<User> queryAllUser() throws Exception;


}
